Install phpMyAdmin
2017/06/27 |
Install phpMyAdmin to operate MariaDB on web browser from Clients.
|
|
[1] | |
[2] | |
[3] | Install phpMyAdmin. |
root@www:~#
apt -y install phpmyadmin php-mbstring php-gettext # select which one you using (this example selects apache2) +------------------------+ Configuring phpmyadmin +-------------------------+ | Please choose the web server that should be automatically configured to | | run phpMyAdmin. | | | | Web server to reconfigure automatically: | | | | [*] apache2 | | [ ] lighttpd | | | | | | <Ok> | | | +---------------------------------------------------------------------------+ # answer [No] to proceed on this example +------------------------+ Configuring phpmyadmin +-------------------------+ | | | The phpmyadmin package must have a database installed and configured | | before it can be used. This can be optionally handled with | | dbconfig-common. | | | | If you are an advanced database administrator and know that you want to | | perform this configuration manually, or if your database has already | | been installed and configured, you should refuse this option. Details | | on what needs to be done should most likely be provided in | | /usr/share/doc/phpmyadmin. | | | | Otherwise, you should probably choose this option. | | | | Configure database for phpmyadmin with dbconfig-common? | | | | <Yes> <No> | | | +---------------------------------------------------------------------------+ # change some settings to enable login to phpMyAdmin with root root@www:~# mysql -u root -p mysql Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 11 Server version: 10.1.23-MariaDB-9+deb9u1 Debian 9.0 Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [mysql]> update user set plugin='' where user='root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [mysql]> flush privileges; Query OK, 0 rows affected (0.00 sec) MariaDB [mysql]> exit Bye
root@www:~#
vi /etc/phpmyadmin/apache.conf # line 8: add IP you allow to access
Require ip 127.0.0.1 10.0.0.0/24
systemctl restart apache2 |
[4] | Access to [http://(your hostname or IP address)/phpmyadmin/] and login with a user in MariaDB. |
[5] | Just logined. It's possible to operate MariaDB on here. |